Select a Automobile to update: ---------
Estimate: ---------8,Est Cost $200
9,Est Cost $100
10,Est Cost $3333

Mechanic: ---------1,Jimmy ToolBox
2,Grant EngineFixer
3,Eugene NeedaPart

Repair: ---------5 Brakes 4 hours, $200
6 Engine 3 hours, $400
7 Oil Change 1 hours, $50
8 Tinted Windows 2 hours, $100

Date Started:
Date Completed:[Can be left null]

The sql for the insert
INSERT INTO Job VALUES (NULL, '', '', '', '', NULL)

Second Sql
INSERT INTO RepairJob VALUES ('',' 30')

Job ID	Car ID	Estimate ID	Mechanic ID	Date Started	Date Completed
25	62	8	1	2023-04-25	2023-04-26
26	63	8	2	2023-04-25	2023-04-27
27	64	8	3	2023-04-24	2023-04-25
28	65	8	2	2023-04-25	2023-04-28
29	66	8	1	2023-04-30
30	67	9	3	2023-04-12	2023-04-27

Back to the body shop page
Back to my home page